{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["This workbook contains eight VBA functions"]
["for working with pre-1900 dates."]
[]
["Examples: President Birthdays"]
[]
["President","Year","Month","Day","XDATE","XDATEDIF","XDATEYEARDIF","XDATEDOW"]
["George Washington  ",1732,2,22,{"$f":"xdate(B7,C7,D7,\"mmmm d, yyyy\")","v":"February 22, 1732"},{"$f":"xdatedif(TODAY(),E7)","v":101501},{"$f":"xdateyeardif(E7,TODAY())","v":277},{"$f":"CHOOSE(xdatedow(E7),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Friday"}]
["John Adams ",1735,10,30,{"$f":"xdate(B8,C8,D8,\"mmmm d, yyyy\")","v":"October 30, 1735"},{"$f":"xdatedif(TODAY(),E8)","v":100155},{"$f":"xdateyeardif(E8,TODAY())","v":274},{"$f":"CHOOSE(xdatedow(E8),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Sunday"}]
["Thomas Jefferson ",1743,4,13,"April 13, 1743",97433,266,"Saturday"]
["James Madison ",1751,3,16,"March 16, 1751",94539,258,"Tuesday"]
["James Monroe ",1758,4,28,"April 28, 1758",91939,251,"Friday"]
["John Quincy Adams ",1767,7,11,"July 11, 1767",88578,242,"Saturday"]
["Andrew Jackson ",1767,3,15,"March 15, 1767",88696,242,"Sunday"]
["Martin Van Buren ",1782,12,5,"December 5, 1782",82952,227,"Thursday"]
["William Henry Harrison ",1773,2,9,"February 9, 1773",86538,236,"Tuesday"]
["John Tyler ",1790,3,29,"March 29, 1790",80281,219,"Monday"]
["James K. Polk ",1795,11,2,"November 2, 1795",78237,214,"Monday"]
["Zachary Taylor ",1784,11,24,"November 24, 1784",82232,225,"Wednesday"]
["Millard Fillmore ",1800,1,7,"January 7, 1800",76710,210,"Tuesday"]
["Franklin Pierce ",1804,11,23,"November 23, 1804",74929,205,"Friday"]
["James Buchanan ",1791,4,23,"April 23, 1791",79891,218,"Saturday"]
["Abraham Lincoln ",1809,2,12,"February 12, 1809",73387,200,"Sunday"]
["Andrew Johnson ",1808,12,29,"December 29, 1808",73432,201,"Thursday"]
["Ulysses S. Grant ",1822,4,27,"April 27, 1822",68565,187,"Saturday"]
["Rutherford B. Hayes ",1822,10,4,"October 4, 1822",68405,187,"Friday"]
["James A. Garfield ",1831,11,19,"November 19, 1831",65072,178,"Saturday"]
["Chester A. Arthur ",1829,10,5,"October 5, 1829",65847,180,"Monday"]
["Grover Cleveland ",1837,3,18,"March 18, 1837",63126,172,"Saturday"]
["Benjamin Harrison ",1833,8,20,"August 20, 1833",64432,176,"Tuesday"]
["William McKinley ",1843,1,29,"January 29, 1843",60983,166,"Sunday"]
["Theodore Roosevelt ",1858,10,27,"October 27, 1858",55233,151,"Wednesday"]
["William Howard Taft ",1857,9,15,"September 15, 1857",55640,152,"Tuesday"]
["Woodrow Wilson ",1856,12,28,"December 28, 1856",55901,153,"Sunday"]
["Warren G. Harding ",1865,11,2,"November 2, 1865",52670,144,"Thursday"]
["Calvin Coolidge ",1872,7,4,"July 4, 1872",50234,137,"Thursday"]
["Herbert Hoover ",1874,8,10,"August 10, 1874",49467,135,"Monday"]
["Franklin D. Roosevelt ",1882,1,30,"January 30, 1882",46737,127,"Monday"]
["Harry S Truman ",1884,5,8,"May 8, 1884",45908,125,"Thursday"]
["Dwight D. Eisenhower ",1890,10,14,"October 14, 1890",43558,119,"Tuesday"]
["John Kennedy ",1917,5,29,"May 29, 1917",33835,92,"Tuesday"]
["Lyndon B. Johnson ",1908,8,27,"August 27, 1908",37032,101,"Thursday"]
["Richard M. Nixon ",1913,1,9,"January 9, 1913",35436,97,"Thursday"]
["Gerald R. Ford ",1913,7,14,"July 14, 1913",35250,96,"Monday"]
["Jimmy Carter ",1924,10,1,"October 1, 1924",31153,85,"Wednesday"]
["Ronald Reagan ",1911,2,6,"February 6, 1911",36139,98,"Monday"]
["George H. W. Bush ",1924,6,12,"June 12, 1924",31264,85,"Thursday"]
["William J. Clinton ",1946,8,19,"August 19, 1946",23161,63,"Monday"]
["George W. Bush ",1946,7,6,"July 6, 1946",23205,63,"Saturday"]

{"sheet":"Sheet2","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Count of XDATEDOW"]
["Sunday",0.11904761904761904]
["Monday",0.19047619047619047]
["Tuesday",0.16666666666666666]
["Wednesday",7.1428571428571425E-2]
["Thursday",0.19047619047619047]
["Friday",9.5238095238095233E-2]
["Saturday",0.16666666666666666]
["Grand Total",1]
[]
[]
[]
[]
["Row Labels","Count of Month"]
[1,9.5238095238095233E-2]
[2,9.5238095238095233E-2]
[3,9.5238095238095233E-2]
[4,9.5238095238095233E-2]
[5,4.7619047619047616E-2]
[6,2.3809523809523808E-2]
[7,9.5238095238095233E-2]
[8,9.5238095238095233E-2]
[9,2.3809523809523808E-2]
[10,0.14285714285714285]
[11,0.11904761904761904]
[12,7.1428571428571425E-2]
["Grand Total",1]